package com.techysky.repository;

import java.io.Serializable;
import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.techysky.entity.ExamOnTheSpot;

public interface ExamOnTheSpotRepository extends CoreRepository<ExamOnTheSpot, Serializable> {
	@Query(value="select u.id,u.user_name from sys_user u where u.id not in (select eo.user_id from sys_exam_onthespot  eo where eo.paper_id=?1)",nativeQuery=true)
	List<Object> findExaminationOnTheSpotUser(String paperId);
}
